UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChNHdUqmKOKkTd4V19f0pJIOxa+C6tLJOoi79m2ICT8='
WHERE
key_id = '4e9813de4e94927b5cbcdbeda382cc19c350bfbe3ef3c5ea9d56ab6ea6d3f677'
AND (
token = 'ChNHdUqmKOKkTd4V19f0pJIOxa+C6tLJOoi79m2ICT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)