UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfXT+hQ3OsL4apRXjjfCdZpb35DsshYOif/ehx9Mlcg='
WHERE
key_id = '40b6a5d53faefea05c15a73c78525304dd61f834ef64c6ba70c51b44d30f878a'
AND (
token = 'XfXT+hQ3OsL4apRXjjfCdZpb35DsshYOif/ehx9Mlcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)