UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krn3hNgTPIemS3Guzhp/Zd11oIG/EQ1McpV9sEaCUsA='
WHERE
key_id = 'f61cfc4615b82d0ef04bef51846a80078439af0eb131bd3de5a347c6ca5b210e'
AND (
token = 'krn3hNgTPIemS3Guzhp/Zd11oIG/EQ1McpV9sEaCUsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)