UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dGIhsvDJLRDVi0xotxL2afoJY/HrWIn7JtBDXynL8eY='
WHERE
key_id = 'a5a66a3f3ca7e37bf7d41ef82a06d2cffa82d778f8cc7c93a8df862d61905d97'
AND (
token = 'dGIhsvDJLRDVi0xotxL2afoJY/HrWIn7JtBDXynL8eY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)