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