UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7i4YZBFrNTpN4VNEjzHsLNj2mEa/v53La4p59HW7FZs='
WHERE
key_id = 'ec55eae12ad79c12b71f0d66939c37ec609092946ef6cb7aec09ce32a705148f'
AND (
token = '7i4YZBFrNTpN4VNEjzHsLNj2mEa/v53La4p59HW7FZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)