UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdcQ7WWdH6wDRnzeAA48V9z8vsyDor7jrg2kE6R03H8='
WHERE
key_id = '391b259e1ca3ff31de076b16d73ba292f4ca43e77dc77cd57d4a607f8b960358'
AND (
token = 'pdcQ7WWdH6wDRnzeAA48V9z8vsyDor7jrg2kE6R03H8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)