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