UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ap8wMK/AacLcOTCxnnvHXJjW0pHK2YY/C3HlQQqOuJY='
WHERE
key_id = 'd816521a5e4f5e93adb0def4050cbdde4fb5054282dd558ae460f866feb3e960'
AND (
token = 'Ap8wMK/AacLcOTCxnnvHXJjW0pHK2YY/C3HlQQqOuJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)