UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yjGVS4i0tUonK0IGkkDHW81yOIhoJZEj5petUq8+yEY='
WHERE
key_id = '9f2e930d6348298d58e6d5c2372c49e206d7057620beefe6b015826cd6dded5f'
AND (
token = 'yjGVS4i0tUonK0IGkkDHW81yOIhoJZEj5petUq8+yEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)