UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D8nDTavwv9nh6FmjbAZ8LDdaVE40U+vBEWl+MPFs81E='
WHERE
key_id = 'b62757d506db428a6bb427ffc7a0fbee64fb16552da4cfd22166de5c2012b488'
AND (
token = 'D8nDTavwv9nh6FmjbAZ8LDdaVE40U+vBEWl+MPFs81E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)