UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9WMBNLhIxRGE2W+TpayyQ+4tCaADXfn7CU/6P2gVUYk='
WHERE
key_id = 'b5668f3f01c35de5609adc7abb5e8855765969b98186e5ef1b6ca2acc66dc4e5'
AND (
token = '9WMBNLhIxRGE2W+TpayyQ+4tCaADXfn7CU/6P2gVUYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)