UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x3pnnGYQdS+h71GfI1mo+KjaCJG0ttwkKV7snBiQU0U='
WHERE
key_id = '326885c8d71d20c7b8a033b75e76198941f0875a263e84bf74a7b24239fe483f'
AND (
token = 'x3pnnGYQdS+h71GfI1mo+KjaCJG0ttwkKV7snBiQU0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)