UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ADKpNVGTqmh7RK4hHFoBv7UijZYnyV9BDoM6u698CSo='
WHERE
key_id = '7d46558476075d4c0618d663c5717623d21b1827b4237646f8ac1cf37b6d3440'
AND (
token = 'ADKpNVGTqmh7RK4hHFoBv7UijZYnyV9BDoM6u698CSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)