UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4puEYX29srraFMhFtcoWbo6+SUvA1I1HjuAY7fAJ67g='
WHERE
key_id = 'e7f2c1bf49c351131aec3103c1941ba379cc331c99beeca02ee1268ced31f514'
AND (
token = '4puEYX29srraFMhFtcoWbo6+SUvA1I1HjuAY7fAJ67g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)