UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYnSw18ktHoWqeL6ZUfk16dz9fxcuKEuEUpa0CNFuq4='
WHERE
key_id = '00b9077e5b5e1e18fc36d6347929f6d5cc9a6780aaec8593ba55d679332c806c'
AND (
token = 'kYnSw18ktHoWqeL6ZUfk16dz9fxcuKEuEUpa0CNFuq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)