UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ci0QQLDmKs2s+adPvnGCaZol934MCTD7H1KjJytKGNU='
WHERE
key_id = 'bd8cf7455f29ba70088c4a05bf2211db8d21788e0e177f605bfbb957c4f0f49a'
AND (
token = 'ci0QQLDmKs2s+adPvnGCaZol934MCTD7H1KjJytKGNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)