UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDk2ZXTJTarFgRLur8Tc0KnFz6t8l9IjIudjkUoiYfY='
WHERE
key_id = 'ab7c055f31266dce6597888a27c2dc147c0d079f111e9969c25271167d399bc9'
AND (
token = 'CDk2ZXTJTarFgRLur8Tc0KnFz6t8l9IjIudjkUoiYfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)