UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qb6wZhIrW05YoMO+25WAdi5U2pSU4I1+Ng6P2dbl+k4='
WHERE
key_id = '6b864cf57dc9a65aa89eb9f9fdd0d5ffe62021cc4a27c7e8410fd87b0aa50b63'
AND (
token = 'Qb6wZhIrW05YoMO+25WAdi5U2pSU4I1+Ng6P2dbl+k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)