UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bP82qvoC9FBh2dazLFXIMDb8Kh9LDGf3fQAvc3aCcyw='
WHERE
key_id = 'f4a746b864088633886a4694d7de1a67b8df052cc9e52c28a4138d52d7ae1594'
AND (
token = 'bP82qvoC9FBh2dazLFXIMDb8Kh9LDGf3fQAvc3aCcyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)