UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JmN8LfpLfhjrsha1Z/AtnFCl2HbgTbPoy4Q/dUXNEp0='
WHERE
key_id = '28535eaf8bb6f1b7a4fa61ef865d6f3aecabb451ca1457c5ce4c4fdd65f472a5'
AND (
token = 'JmN8LfpLfhjrsha1Z/AtnFCl2HbgTbPoy4Q/dUXNEp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)