UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UB3hw1sIsJOK6AKIcGAa1MR9BgJ67xkEBQNRii5+exw='
WHERE
key_id = '4da937984c0f0d7fa46bbcbbf2410c04cfc3cec726d8de5bd8454ca0cd0fcae0'
AND (
token = 'UB3hw1sIsJOK6AKIcGAa1MR9BgJ67xkEBQNRii5+exw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)