UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yv4nyUtXm8BABFSGC1SHlChM4n1YV2smHsNl30tLCL8='
WHERE
key_id = 'bf6b3364978c118b610927ec8ae0eeb29fba9f4af985ce06e4d771ec1269b70c'
AND (
token = 'yv4nyUtXm8BABFSGC1SHlChM4n1YV2smHsNl30tLCL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)