UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWc9VJDwHdb3EbSPtpmsFNIdNmc9Pdbv9N7fUd1DmN0='
WHERE
key_id = '1f070698bdcab3bd80b22c8d28df4f084883a194889643c0dc9b343d76ec5f28'
AND (
token = 'nWc9VJDwHdb3EbSPtpmsFNIdNmc9Pdbv9N7fUd1DmN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)