UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'On1S5ZqI5jEh3G5BewwLcdggydbo2QjiLcvR8Kqu6VA='
WHERE
key_id = '513a8cf88b24dfaf5cea76e484a5427260fb96bc71e6900f0f50b0b29012d62f'
AND (
token = 'On1S5ZqI5jEh3G5BewwLcdggydbo2QjiLcvR8Kqu6VA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)