UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8B0BZEChYs752BzzGoF5yUOvwFInfh4OeGh6Q05EZL4='
WHERE
key_id = 'bc67f7fa306d5d670389b4f46fc17fc666ed1d1c254428f9d284d62b625ec394'
AND (
token = '8B0BZEChYs752BzzGoF5yUOvwFInfh4OeGh6Q05EZL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)