UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QF/3kc3Od6NJ56drqJVJ0tActJ18TTOKTB8Up7Lj72A='
WHERE
key_id = '8891bb2cf0ccb02f5af9565d7f61a3500a0d90f949a0227d2765ea153285299f'
AND (
token = 'QF/3kc3Od6NJ56drqJVJ0tActJ18TTOKTB8Up7Lj72A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)