UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3LocWwzhq+N31QyH6kmeS5kQYmCxqnTC8I7XGipNwVw='
WHERE
key_id = 'b6c8d0ca712a3591e0b217d57b474fe8fdc544ed0f904de3a38de09a43e3667e'
AND (
token = '3LocWwzhq+N31QyH6kmeS5kQYmCxqnTC8I7XGipNwVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)