UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NFaOcJ6Td54HMNaEfQSGe5z4py8SxOFuRIWP4SZ60Co='
WHERE
key_id = 'e77e8da0a263f04a4ddaf4a2ffbeb9b806b0cd38d308d4e546f182bcec3ac0a5'
AND (
token = 'NFaOcJ6Td54HMNaEfQSGe5z4py8SxOFuRIWP4SZ60Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)