UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvN8npa3DjAxK+clTAD34fm+gdmCpWpVENXm7SB6rXs='
WHERE
key_id = 'e496d01fa78ef2ad5fe2eb572e2132ea77a4719b13ef455c34a008f0edf0df16'
AND (
token = 'qvN8npa3DjAxK+clTAD34fm+gdmCpWpVENXm7SB6rXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)