UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RTNq9LSkp5VzQxME7u6Qpf6+el8y+WhUdY1woP/gPcw='
WHERE
key_id = '27462e9edb1b72e8b432f8b2976a8bb1f734a000f5c2e04bc899582078bad620'
AND (
token = 'RTNq9LSkp5VzQxME7u6Qpf6+el8y+WhUdY1woP/gPcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)