UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvck4jj4bXI2mitOoe7s7vwU8tHcIsaU9EWvoo7pDCs='
WHERE
key_id = '0bc01cc61e50b7069983f542bd6911f6449cb6158ecdffcc9d9ea839bc96c328'
AND (
token = 'vvck4jj4bXI2mitOoe7s7vwU8tHcIsaU9EWvoo7pDCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)