UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vxUQ8NTRkL+o0P5vvLY/oDtiFcmQp9XCWYrFkgMu084='
WHERE
key_id = 'd8d8028fcf8831d31ac7f889883e41e813faea6701af2f2a3363c86d07732ad7'
AND (
token = 'vxUQ8NTRkL+o0P5vvLY/oDtiFcmQp9XCWYrFkgMu084='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)