UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n0xkDMHYofbvdji/+n4l8ABjJ2A47unikE8Rdq9PNYg='
WHERE
key_id = '1c30b6d8de4b797ebe1823b42c0bca59953c60ad61bc2fed964d3e9df54969d1'
AND (
token = 'n0xkDMHYofbvdji/+n4l8ABjJ2A47unikE8Rdq9PNYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)