UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTPkfXGwS7VqZrLVostvYB5xLh2CsDXw8Na7dftlHls='
WHERE
key_id = '8c9c3b4d3f891381551bebfbd7d9c84587182926a008863e991b0cc1d12fedb5'
AND (
token = 'VTPkfXGwS7VqZrLVostvYB5xLh2CsDXw8Na7dftlHls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)